2013-09-11 - 8481.700 - Rel Notes - Assist with Crystal Report updates - Release 005 #BIReleases2013

Release Notes

8481.700 - Assist with Crystal Report updates

Admin Info


Purpose
Need to update Crystal reports from 7.0 to 7.3 for sales analysis, open orders and service levels
Release No
005
Submitted
10/03/2013
Submitted by
Praveen Guntuka
Source/Destination Systems
NBP to BPD
Release Sent To
Jack Mehltretter
Object(s) Created By
Praveen Guntuka
Object(s) Tested By
Praveen Guntuka

Report Name(s)


Below are the list of Crystal Reports and their respective BW 7.0 Production and BW 7.3 Development queries:

SNo
Folder
Report
Source
BW Query
New BW Query
1.
Inventory
INV010 - Available to Promise Inventory by SBU and Season
BW
ZDSOATP_Q003
ZDSOINVD_Q001
2.
Inventory
INV015 - Available to Promise Inventory ROC Excluded
BW
ZDSOATP_Q004
ZDSOINVD_Q002
3.
Inventory
INV300 – Stock Inventory Analysis
BW
ZDSOINV2_Q005
ZDSOINVM_Q001
4.
Inventory
INV310 – Non-Replenished Inventory Analysis
BW
ZDSOINV2_Q006
ZDSOINVM_Q002
5.
Inventory
INV350 - Consolidated Inventory Analysis
BW
ZDSOINE2_Q001
ZDSOINVM_Q003
6.
Financial Statements
FI100 - Consolidated Income Statement
BW
ZMP_GLPC_Q001
ZMP_GLPC_Q001
7.
Financial Statements
FI110 - Income Statement
BW
ZMP_GLPC_Q001
ZMP_GLPC_Q001
8.
Financial Statements
FI112 - Income Statement with Last Year
BW
1) ZMP_GLPC_Q004
2) ZMP_GLPC_Q001
1)ZMP_GLPC_Q001
2)ZMP_GLPC_Q001
9.
Financial Statements
FI113 - Income Statement with Last Year Actuals Only
BW
ZMP_GLPC_Q001
ZMP_GLPC_Q001
10.
Financial Statements
FI115 - Income Statement with Detail
BW
ZMP_GLPC_Q001
ZMP_GLPC_Q001
11.
Financial Statements
FI120 - Income Statement in company currency
BW
ZMP_GLPC_Q003
ZMP_GLPC_Q003
12.
Financial Statements
FI130 - Income Statement by SBU
BW
ZMP_GLPC_Q002
ZMP_GLPC_Q002
13.
Financial Statements - Preliminary
FI100 - Consolidated Income Statement
BW
ZMP_GLPC_Q001
ZMP_GLPC_Q001
14.
Financial Statements - Preliminary
FI110 - Income Statement
BW
ZMP_GLPC_Q001
ZMP_GLPC_Q001
15.
Financial Statements - Preliminary
FI112 - Income Statement with Last Year
BW
1) ZMP_GLPC_Q004
2) ZMP_GLPC_Q001
1)ZMP_GLPC_Q001
2)ZMP_GLPC_Q001
16.
Financial Statements - Preliminary
FI113 - Income Statement with Last Year Actuals Only
BW
ZMP_GLPC_Q001
ZMP_GLPC_Q001
17.
Financial Statements - Preliminary
FI115 - Income Statement with Detail
BW
ZMP_GLPC_Q001
ZMP_GLPC_Q001
18.
Financial Statements - Preliminary
FI120 - Income Statement in company currency
BW
ZMP_GLPC_Q003
ZMP_GLPC_Q003
19.
Financial Statements - Preliminary
FI130 - Income Statement by SBU
BW
ZMP_GLPC_Q002
ZMP_GLPC_Q002

Release Notes


For Infrastructure

None

For Requestor

Updated Crystal Reports are placed in IT > BMS > Production > BPD folder.

Test Notes

No need to validate the above reports, untill the sources in BW are moved to quality.

Reference Document(Specification)


2013-09-11 - 8481.700 - Spec - Assist with Crystal Report updates
2013-09-11 - 8481.700 - Rel Notes - Assist with Crystal Report updates - Release 001
2013-09-11 - 8481.700 - Rel Notes - Assist with Crystal Report updates - Release 002
2013-09-11 - 8481.700 - Rel Notes - Assist with Crystal Report updates - Release 003
2013-09-11 - 8481.700 - Rel Notes - Assist with Crystal Report updates - Release 004